package com.example.practical_training_projects.mapper;

import com.example.practical_training_projects.entity.working_schedule;
import org.apache.ibatis.annotations.*;

import java.util.List;


@Mapper
public interface work_scheduleMapper {
    @Insert("INSERT INTO working_schedule (ws_date, time1, time2, time3, state1, state2, state3, pc_uid) VALUES (#{ws_date}, #{time1}, #{time2}, #{time3}, #{state1}, #{state2}, #{state3}, #{pc_uid})")
    Integer insertworktime(working_schedule work);

    @Select("select *from  working_schedule where pc_uid=#{pc_uid}")
    List<working_schedule> selectpcwork(Integer pc_uid);
    @Delete("DELETE FROM working_schedule where ws_id = #{ws_id}")
    Integer deletepcworkbyid(@Param("ws_id") Integer ws_id);
}

